package com.htgd.gardenexpo.dao;

import com.htgd.gardenexpo.entity.GeConFood;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.htgd.gardenexpo.page.FoodQuery;
import com.htgd.gardenexpo.page.PageBase;
import com.htgd.gardenexpo.vo.GeConFoodRankingVO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * <p>
 * 美食表 Mapper 接口
 * </p>
 *
 * @author author
 * @since 2024-04-08
 */
@Mapper
public interface GeConFoodDao extends BaseMapper<GeConFood> {

    GeConFood queryById(Integer id);

    List<GeConFood> querylist(FoodQuery foodQuery);

    List<GeConFoodRankingVO> getRanking();
    @Select("SELECT * FROM `ge_con_food` WHERE shop_id = #{shopId} and delete_flag = '0'")
    List<GeConFood> getListByShopId(@Param("shopId") String shopId);
    @Select("SELECT * FROM `ge_con_food` WHERE shop_id = #{shopId} and status = '3'")
    List<GeConFood> getReleaseListByShopId(@Param("shopId") String shopId);
}
